CREATE VIEW [dbo].[vSoaGroupSummaryRelationship]
WITH SCHEMABINDING
AS
    SELECT  'RELATIONSHIP-' + [n].[ID] AS [GroupId],
            'Party' AS [ParentEntityTypeName],
            [n].[ID] AS [ParentEntityId],
            'RELATIONSHIP' AS [GroupClassId],
            'Relationships' AS [Name]
      FROM  [dbo].[Name] AS [n]


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryRelationship] ON [dbo].[vSoaGroupSummaryRelationship] ([GroupId]) ON [PRIMARY]
GO